﻿IF object_id(N'dbo.UDS_CM_Attachment', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_CM_Attachment] (
        [ID]        int          NOT NULL identity(1, 1),
        [Path]      nvarchar(500) COLLATE Chinese_PRC_CI_AS NULL,
        [Type]      nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
        [PertainID] int          NULL,
        [Extension] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,

        CONSTRAINT [PK_UDS_CM_Attachment] PRIMARY KEY CLUSTERED ([ID] asc)
    );
END
GO
